b534672b278724d3719e8c4a6c46abea7245ab42,thunderbirdparser/src/org/sleuthkit/autopsy/thunderbirdparser/ThunderbirdMboxFileIngestModule.java,ThunderbirdMboxFileIngestModule,process,#AbstractFile#,83
Before Change
Long mboxId = abstractFile.getId();
String mboxPath = "";
Long msfId = 0L;
Case currentCase = Case.getCurrentCase(); // get the most updated case
SleuthkitCase tskCase = currentCase.getSleuthkitCase();
try {
ResultSet rs = tskCase.runQuery("select parent_path from tsk_files where obj_id = '" + mboxId.toString() + "'");
mboxPath = rs.getString("parent_path");
Statement s = rs.getStatement();
rs.close();
if (s != null) {
s.close();
}
rs.close();
After Change
//Long mboxId = fsContent.getId();
String mboxPath = fsContent.getParentPath();
Long msfId = 0L;
currentCase = Case.getCurrentCase(); // get the most updated case
SleuthkitCase tskCase = currentCase.getSleuthkitCase();
try {
ResultSet resultset = tskCase.runQuery("SELECT obj_id FROM tsk_files WHERE parent_path = '" + mboxPath + "' and name = '" + msfName + "'");